🕷️️ Job Radar • SCRAPING

freelancer.com 🟢 2026-05-03

🔹 Automated Data Scraping for Product Details
👤 Client: 🇬🇧 Edinburgh,, United Kingdom Member since 2012-07-04
💰 Price: $58 Average bid
🚩 Problem: Capture product details from three specific URLs and deliver them into a structured Excel file.
📦 Existing: Not specified

Specifications:

[Target] - Extract data from the provided URLs: 214-9565 | RS PRO, CB22335 | Z Type Cable Marker 0, Straight Cut, White, 7.9-12.7 mm, Box 250
[Method] - Use web scraping tools to automate data extraction.
[UI/UX] - Not applicable
[Stack] - Python with BeautifulSoup or Scrapy for scraping; Pandas for data manipulation; Openpyxl for Excel file generation.
[Security] - Ensure no sensitive information is exposed during the process. Follow ethical scraping practices.
[Format] - Deliver a single Excel workbook with one worksheet containing columns: Product code, full product name, current list price (ex-VAT), stated quantity/pack size, full description/specification text, source URL.

Workflow:

1. Define the data extraction rules for each field based on the provided URLs.
2. Set up a Python environment with necessary libraries: BeautifulSoup or Scrapy, Pandas, and Openpyxl.
3. Write scraping scripts to extract required fields from each URL.
4. Clean and validate scraped data against live pages.
5. Structure the data into a consistent format using Pandas DataFrame.
6. Generate an Excel file with the structured data using Openpyxl.
7. Test the generated Excel file in Microsoft Excel 365 for any errors.